package com.rao.travel.dao;

import com.rao.travel.pojo.Traveller;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Srao
 * @version 1.0
 * @className travellerDao
 * @date 2019/10/29 19:12
 * @package com.rao.travel.dao
 * @description
 */
@Mapper
public interface travellerDao {

    /*根据订单编号查询订单所对应的游客*/
    @Select("select * from traveller where id = (select travellerId from order_traveller where orderId = #{orderId})")
    List<Traveller> findByOrdersId(String orderId) throws Exception;
}
